i have created a snapshot that takes data from 2 tables and has a refresh rate of 1 day. The snapshot data is not refreshing it is still the same. is there something that i am

missing ?

Here is the code:

CREATE SNAPSHOT test

REFRESH COMPLETE

    START WITH SYSDATE 

    NEXT sysdate + 1

AS

select item_code,item_conc_code,tran_bran_code,sum(tran_qty) bal_qty

from tranhist a,

 itemmast b

where a.tran_item_code = b.item_code

group by item_code,item_conc_code,tran_bran_code